Overview
Brought to you by YData
Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 3149405 |
| Missing cells | 41039307 |
| Missing cells (%) | 40.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 768.9 MiB |
| Average record size in memory | 256.0 B |
Variable types
| Numeric | 11 |
|---|---|
| Text | 8 |
| Categorical | 4 |
| DateTime | 6 |
| Unsupported | 3 |
MONTO_DE_COMISIONES has constant value "0.0" | Constant |
INTERES_LIMPIO_FUTURO has constant value "0.0" | Constant |
CUSTOMER_ID is highly overall correlated with OBJETIVO_DEL_FIDEICOMISO and 1 other fields | High correlation |
ID_DISPERSION is highly overall correlated with ID_TRANSACTION | High correlation |
ID_TRANSACTION is highly overall correlated with ID_DISPERSION and 2 other fields | High correlation |
MONTO_BRUTO is highly overall correlated with MONTO_SERIE_PRI and 1 other fields | High correlation |
MONTO_DISPERSION is highly overall correlated with OBJETIVO_DEL_FIDEICOMISO | High correlation |
MONTO_ORDENADO is highly overall correlated with MONTO_SERIE_PRI and 1 other fields | High correlation |
MONTO_SERIE_PRI is highly overall correlated with MONTO_BRUTO and 1 other fields | High correlation |
OBJETIVO_DEL_FIDEICOMISO is highly overall correlated with CUSTOMER_ID and 3 other fields | High correlation |
OID_CUSTOMERS is highly overall correlated with CUSTOMER_ID and 1 other fields | High correlation |
SUBTIPO_TX is highly overall correlated with MONTO_BRUTO and 1 other fields | High correlation |
TASA_DE_TRANSACCION is highly overall correlated with ID_TRANSACTION | High correlation |
RFC is highly imbalanced (91.9%) | Imbalance |
SUBTIPO_TX is highly imbalanced (69.9%) | Imbalance |
RFC has 44210 (1.4%) missing values | Missing |
FECHA_DE_LIQUIDACION has 90735 (2.9%) missing values | Missing |
FECHA_DE_FIN_DE_TRANSACCION has 1337566 (42.5%) missing values | Missing |
TASA_DE_TRANSACCION has 1337566 (42.5%) missing values | Missing |
COMENTARIOS_TX has 2346822 (74.5%) missing values | Missing |
CONCEPTO_TX has 2347232 (74.5%) missing values | Missing |
OBJETIVO_DEL_FIDEICOMISO has 2983785 (94.7%) missing values | Missing |
SUBTIPO_TX has 2168606 (68.9%) missing values | Missing |
INTERES_LIMPIO_FUTURO has 2799144 (88.9%) missing values | Missing |
EXCEDENTE_UTILIZADO has 3149405 (100.0%) missing values | Missing |
MONTO_EN_DOLARES has 3149405 (100.0%) missing values | Missing |
TASA_DE_CAMBIO_DOLARES has 3149405 (100.0%) missing values | Missing |
MONTO_BRUTO has 2796429 (88.8%) missing values | Missing |
MONTO_ORDENADO has 3146676 (99.9%) missing values | Missing |
ID_DISPERSION has 2546749 (80.9%) missing values | Missing |
MONTO_DISPERSION has 2546749 (80.9%) missing values | Missing |
NOMBRE_DE_BENEFICIARIO has 2546749 (80.9%) missing values | Missing |
RFC_BENEFICIARIO has 2546749 (80.9%) missing values | Missing |
CUSTOMER_ID is highly skewed (γ1 = 42.03372401) | Skewed |
MONTO_SERIE_PRI is highly skewed (γ1 = 323.4741729) | Skewed |
MONTO_DISPERSION is highly skewed (γ1 = 40.46518368) | Skewed |
EXCEDENTE_UTILIZADO is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
MONTO_EN_DOLARES is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TASA_DE_CAMBIO_DOLARES is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TASA_DE_TRANSACCION has 57852 (1.8%) zeros | Zeros |
Reproduction
| Analysis started | 2025-03-12 01:11:29.262979 |
|---|---|
| Analysis finished | 2025-03-12 01:14:02.277926 |
| Duration | 2 minutes and 33.01 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
OID_CUSTOMERS
Real number (ℝ)
High correlation
| Distinct | 292 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4256.0073 |
| Minimum | 3087 |
|---|---|
| Maximum | 8763 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 3087 |
|---|---|
| 5-th percentile | 3091 |
| Q1 | 3091 |
| median | 4390 |
| Q3 | 4436 |
| 95-th percentile | 6317 |
| Maximum | 8763 |
| Range | 5676 |
| Interquartile range (IQR) | 1345 |
Descriptive statistics
| Standard deviation | 1257.5454 |
|---|---|
| Coefficient of variation (CV) | 0.29547539 |
| Kurtosis | 2.0715203 |
| Mean | 4256.0073 |
| Median Absolute Deviation (MAD) | 1299 |
| Skewness | 1.3648857 |
| Sum | 1.3403891 × 1010 |
| Variance | 1581420.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3091 | 1084683 | |
| 4423 | 486724 | |
| 3092 | 79434 | 2.5% |
| 4437 | 74907 | 2.4% |
| 4430 | 56736 | 1.8% |
| 5907 | 54289 | 1.7% |
| 4394 | 52818 | 1.7% |
| 5712 | 52228 | 1.7% |
| 4427 | 52000 | 1.7% |
| 8586 | 35943 | 1.1% |
| Other values (282) | 1119643 |
| Value | Count | Frequency (%) |
| 3087 | 10 | < 0.1% |
| 3089 | 26162 | 0.8% |
| 3090 | 51 | < 0.1% |
| 3091 | 1084683 | |
| 3092 | 79434 | 2.5% |
| 3096 | 4470 | 0.1% |
| 3097 | 54 | < 0.1% |
| 3698 | 25 | < 0.1% |
| 3699 | 5762 | 0.2% |
| 3700 | 151 | < 0.1% |
| Value | Count | Frequency (%) |
| 8763 | 34 | |
| 8745 | 1 | < 0.1% |
| 8744 | 1 | < 0.1% |
| 8742 | 1 | < 0.1% |
| 8732 | 1 | < 0.1% |
| 8724 | 1 | < 0.1% |
| 8716 | 1 | < 0.1% |
| 8709 | 1 | < 0.1% |
| 8708 | 1 | < 0.1% |
| 8689 | 1 | < 0.1% |
CUSTOMER_ID
Real number (ℝ)
High correlation Skewed
| Distinct | 292 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77188.937 |
| Minimum | 47 |
|---|---|
| Maximum | 8047912 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 47 |
|---|---|
| 5-th percentile | 10937 |
| Q1 | 80139 |
| median | 80280 |
| Q3 | 80481 |
| 95-th percentile | 80730 |
| Maximum | 8047912 |
| Range | 8047865 |
| Interquartile range (IQR) | 342 |
Descriptive statistics
| Standard deviation | 55920.694 |
|---|---|
| Coefficient of variation (CV) | 0.72446513 |
| Kurtosis | 4926.0751 |
| Mean | 77188.937 |
| Median Absolute Deviation (MAD) | 141 |
| Skewness | 42.033724 |
| Sum | 2.4309923 × 1011 |
| Variance | 3.127124 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 80139 | 1084683 | |
| 80320 | 486724 | |
| 80280 | 79434 | 2.5% |
| 80481 | 74907 | 2.4% |
| 80449 | 56736 | 1.8% |
| 80692 | 54289 | 1.7% |
| 10771 | 52818 | 1.7% |
| 80672 | 52228 | 1.7% |
| 80405 | 52000 | 1.7% |
| 80776 | 35943 | 1.1% |
| Other values (282) | 1119643 |
| Value | Count | Frequency (%) |
| 47 | 148 | < 0.1% |
| 237 | 1217 | < 0.1% |
| 465 | 2984 | |
| 515 | 2883 | |
| 553 | 25 | < 0.1% |
| 567 | 5762 | |
| 586 | 151 | < 0.1% |
| 641 | 132 | < 0.1% |
| 660 | 156 | < 0.1% |
| 1592 | 6972 |
| Value | Count | Frequency (%) |
| 8047912 | 6 | |
| 8047911 | 14 | |
| 8022274 | 1 | < 0.1% |
| 8022273 | 1 | < 0.1% |
| 8022271 | 1 | < 0.1% |
| 8022270 | 1 | < 0.1% |
| 8022265 | 1 | < 0.1% |
| 8022263 | 1 | < 0.1% |
| 8022260 | 1 | < 0.1% |
| 8022259 | 1 | < 0.1% |
LEGAL_NAME
Text
| Distinct | 292 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 24.0 MiB |
Length
| Max length | 106 |
|---|---|
| Median length | 94 |
| Mean length | 45.882149 |
| Min length | 3 |
Unique
| Unique | 24 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Fideicomiso de Contragarantia para el Financiamiento Empresarial |
|---|---|
| 2nd row | Fideicomiso de Contragarantia para el Financiamiento Empresarial |
| 3rd row | Fideicomiso de Contragarantia para el Financiamiento Empresarial |
| 4th row | Fideicomiso de Contragarantia para el Financiamiento Empresarial |
| 5th row | Fideicomiso de Contragarantia para el Financiamiento Empresarial |
| Value | Count | Frequency (%) |
| de | 2436749 | 13.1% |
| fideicomiso | 1349643 | 7.3% |
| para | 1289561 | 7.0% |
| el | 1172337 | 6.3% |
| financiamiento | 1132607 | 6.1% |
| empresarial | 1109839 | 6.0% |
| contragarantia | 1084683 | 5.9% |
| fondo | 802494 | 4.3% |
| pensiones | 623950 | 3.4% |
| del | 608667 | 3.3% |
| Other values (650) | 6930023 |
Most occurring characters
| Value | Count | Frequency (%) |
| 15457441 | 10.7% | |
| a | 13539073 | 9.4% |
| i | 10591336 | 7.3% |
| e | 7911714 | 5.5% |
| r | 6909386 | 4.8% |
| n | 6902453 | 4.8% |
| o | 6900014 | 4.8% |
| E | 6270125 | 4.3% |
| A | 4223876 | 2.9% |
| t | 4126232 | 2.9% |
| Other values (71) | 61669819 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 144501469 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 15457441 | 10.7% | |
| a | 13539073 | 9.4% |
| i | 10591336 | 7.3% |
| e | 7911714 | 5.5% |
| r | 6909386 | 4.8% |
| n | 6902453 | 4.8% |
| o | 6900014 | 4.8% |
| E | 6270125 | 4.3% |
| A | 4223876 | 2.9% |
| t | 4126232 | 2.9% |
| Other values (71) | 61669819 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 144501469 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 15457441 | 10.7% | |
| a | 13539073 | 9.4% |
| i | 10591336 | 7.3% |
| e | 7911714 | 5.5% |
| r | 6909386 | 4.8% |
| n | 6902453 | 4.8% |
| o | 6900014 | 4.8% |
| E | 6270125 | 4.3% |
| A | 4223876 | 2.9% |
| t | 4126232 | 2.9% |
| Other values (71) | 61669819 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 144501469 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 15457441 | 10.7% | |
| a | 13539073 | 9.4% |
| i | 10591336 | 7.3% |
| e | 7911714 | 5.5% |
| r | 6909386 | 4.8% |
| n | 6902453 | 4.8% |
| o | 6900014 | 4.8% |
| E | 6270125 | 4.3% |
| A | 4223876 | 2.9% |
| t | 4126232 | 2.9% |
| Other values (71) | 61669819 |
DESCRIPTION
Text
| Distinct | 292 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 24.0 MiB |
Length
| Max length | 106 |
|---|---|
| Median length | 94 |
| Mean length | 45.890214 |
| Min length | 3 |
Unique
| Unique | 24 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Fideicomiso de Contragarantia para el Financiamiento Empresarial |
|---|---|
| 2nd row | Fideicomiso de Contragarantia para el Financiamiento Empresarial |
| 3rd row | Fideicomiso de Contragarantia para el Financiamiento Empresarial |
| 4th row | Fideicomiso de Contragarantia para el Financiamiento Empresarial |
| 5th row | Fideicomiso de Contragarantia para el Financiamiento Empresarial |
| Value | Count | Frequency (%) |
| de | 2436749 | 13.1% |
| fideicomiso | 1349643 | 7.3% |
| para | 1289561 | 7.0% |
| el | 1172337 | 6.3% |
| financiamiento | 1132607 | 6.1% |
| empresarial | 1109839 | 6.0% |
| contragarantia | 1084683 | 5.8% |
| fondo | 802494 | 4.3% |
| pensiones | 623950 | 3.4% |
| del | 608667 | 3.3% |
| Other values (650) | 6933198 |
Most occurring characters
| Value | Count | Frequency (%) |
| 15460616 | 10.7% | |
| a | 13545423 | 9.4% |
| i | 10594511 | 7.3% |
| e | 7911714 | 5.5% |
| r | 6909386 | 4.8% |
| n | 6902453 | 4.8% |
| o | 6900014 | 4.8% |
| E | 6270125 | 4.3% |
| A | 4223876 | 2.9% |
| t | 4126232 | 2.9% |
| Other values (71) | 61682519 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 144526869 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 15460616 | 10.7% | |
| a | 13545423 | 9.4% |
| i | 10594511 | 7.3% |
| e | 7911714 | 5.5% |
| r | 6909386 | 4.8% |
| n | 6902453 | 4.8% |
| o | 6900014 | 4.8% |
| E | 6270125 | 4.3% |
| A | 4223876 | 2.9% |
| t | 4126232 | 2.9% |
| Other values (71) | 61682519 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 144526869 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 15460616 | 10.7% | |
| a | 13545423 | 9.4% |
| i | 10594511 | 7.3% |
| e | 7911714 | 5.5% |
| r | 6909386 | 4.8% |
| n | 6902453 | 4.8% |
| o | 6900014 | 4.8% |
| E | 6270125 | 4.3% |
| A | 4223876 | 2.9% |
| t | 4126232 | 2.9% |
| Other values (71) | 61682519 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 144526869 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 15460616 | 10.7% | |
| a | 13545423 | 9.4% |
| i | 10594511 | 7.3% |
| e | 7911714 | 5.5% |
| r | 6909386 | 4.8% |
| n | 6902453 | 4.8% |
| o | 6900014 | 4.8% |
| E | 6270125 | 4.3% |
| A | 4223876 | 2.9% |
| t | 4126232 | 2.9% |
| Other values (71) | 61682519 |
RFC
Categorical
Imbalance Missing
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 44210 |
| Missing (%) | 1.4% |
| Memory size | 24.0 MiB |
| XXXXXXXXXXXXX | |
|---|---|
| XXXXXXXXXX | 35943 |
| INF7205011ZA | 13859 |
| XXXXXXXXXXX | 12954 |
| FPI220708J49 | 8536 |
| Other values (5) | 20365 |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 12.943161 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | XXXXXXXXXXXXX |
|---|---|
| 2nd row | XXXXXXXXXXXXX |
| 3rd row | XXXXXXXXXXXXX |
| 4th row | XXXXXXXXXXXXX |
| 5th row | XXXXXXXXXXXXX |
Common Values
| Value | Count | Frequency (%) |
| XXXXXXXXXXXXX | 3013538 | |
| XXXXXXXXXX | 35943 | 1.1% |
| INF7205011ZA | 13859 | 0.4% |
| XXXXXXXXXXX | 12954 | 0.4% |
| FPI220708J49 | 8536 | 0.3% |
| NFF9204099T4 | 6345 | 0.2% |
| XXX000000XXX | 5303 | 0.2% |
| XXXXXXXXXXXX | 4217 | 0.1% |
| AEF8608147R6 | 3487 | 0.1% |
| FGR1812158Z1 | 1013 | < 0.1% |
| (Missing) | 44210 | 1.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| xxxxxxxxxxxxx | 3013538 | |
| xxxxxxxxxx | 35943 | 1.2% |
| inf7205011za | 13859 | 0.4% |
| xxxxxxxxxxx | 12954 | 0.4% |
| fpi220708j49 | 8536 | 0.3% |
| nff9204099t4 | 6345 | 0.2% |
| xxx000000xxx | 5303 | 0.2% |
| xxxxxxxxxxxx | 4217 | 0.1% |
| aef8608147r6 | 3487 | 0.1% |
| fgr1812158z1 | 1013 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| X | 39760340 | |
| 0 | 92785 | 0.2% |
| F | 39585 | 0.1% |
| 2 | 38289 | 0.1% |
| 1 | 35257 | 0.1% |
| 9 | 27571 | 0.1% |
| 7 | 25882 | 0.1% |
| 4 | 24713 | 0.1% |
| I | 22395 | 0.1% |
| N | 20204 | 0.1% |
| Other values (11) | 104017 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 40191038 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| X | 39760340 | |
| 0 | 92785 | 0.2% |
| F | 39585 | 0.1% |
| 2 | 38289 | 0.1% |
| 1 | 35257 | 0.1% |
| 9 | 27571 | 0.1% |
| 7 | 25882 | 0.1% |
| 4 | 24713 | 0.1% |
| I | 22395 | 0.1% |
| N | 20204 | 0.1% |
| Other values (11) | 104017 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 40191038 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| X | 39760340 | |
| 0 | 92785 | 0.2% |
| F | 39585 | 0.1% |
| 2 | 38289 | 0.1% |
| 1 | 35257 | 0.1% |
| 9 | 27571 | 0.1% |
| 7 | 25882 | 0.1% |
| 4 | 24713 | 0.1% |
| I | 22395 | 0.1% |
| N | 20204 | 0.1% |
| Other values (11) | 104017 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 40191038 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| X | 39760340 | |
| 0 | 92785 | 0.2% |
| F | 39585 | 0.1% |
| 2 | 38289 | 0.1% |
| 1 | 35257 | 0.1% |
| 9 | 27571 | 0.1% |
| 7 | 25882 | 0.1% |
| 4 | 24713 | 0.1% |
| I | 22395 | 0.1% |
| N | 20204 | 0.1% |
| Other values (11) | 104017 | 0.3% |
ADDRESS_DUMP
Text
| Distinct | 152 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 24.0 MiB |
Length
| Max length | 127 |
|---|---|
| Median length | 123 |
| Mean length | 83.610548 |
| Min length | 12 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| |
|---|---|
| 2nd row | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| |
| 3rd row | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| |
| 4th row | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| |
| 5th row | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| |
| Value | Count | Frequency (%) |
| 4736654 | 13.9% | |
| inn | 2311978 | 6.8% |
| sur | 1975054 | 5.8% |
| federal|alvaro | 1879735 | 5.5% |
| obregon | 1814523 | 5.3% |
| 1971 | 1775757 | 5.2% |
| guadalupe | 1737978 | 5.1% |
| torre | 1666553 | 4.9% |
| insurgentes | 1331214 | 3.9% |
| 1020|||distrito | 1206613 | 3.6% |
| Other values (599) | 13521795 |
Most occurring characters
| Value | Count | Frequency (%) |
| | | 37792860 | |
| 31174186 | 11.8% | |
| R | 17752381 | 6.7% |
| E | 16980198 | 6.4% |
| I | 15726977 | 6.0% |
| A | 15500189 | 5.9% |
| O | 14692419 | 5.6% |
| N | 12716788 | 4.8% |
| S | 11550985 | 4.4% |
| T | 9289874 | 3.5% |
| Other values (58) | 80146621 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 263323478 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| | | 37792860 | |
| 31174186 | 11.8% | |
| R | 17752381 | 6.7% |
| E | 16980198 | 6.4% |
| I | 15726977 | 6.0% |
| A | 15500189 | 5.9% |
| O | 14692419 | 5.6% |
| N | 12716788 | 4.8% |
| S | 11550985 | 4.4% |
| T | 9289874 | 3.5% |
| Other values (58) | 80146621 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 263323478 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| | | 37792860 | |
| 31174186 | 11.8% | |
| R | 17752381 | 6.7% |
| E | 16980198 | 6.4% |
| I | 15726977 | 6.0% |
| A | 15500189 | 5.9% |
| O | 14692419 | 5.6% |
| N | 12716788 | 4.8% |
| S | 11550985 | 4.4% |
| T | 9289874 | 3.5% |
| Other values (58) | 80146621 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 263323478 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| | | 37792860 | |
| 31174186 | 11.8% | |
| R | 17752381 | 6.7% |
| E | 16980198 | 6.4% |
| I | 15726977 | 6.0% |
| A | 15500189 | 5.9% |
| O | 14692419 | 5.6% |
| N | 12716788 | 4.8% |
| S | 11550985 | 4.4% |
| T | 9289874 | 3.5% |
| Other values (58) | 80146621 |
OID_ACCOUNTS
Real number (ℝ)
| Distinct | 1157 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58617.049 |
| Minimum | 34141 |
|---|---|
| Maximum | 142700 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 34141 |
|---|---|
| 5-th percentile | 34204 |
| Q1 | 37609 |
| median | 38871 |
| Q3 | 78470 |
| 95-th percentile | 113463 |
| Maximum | 142700 |
| Range | 108559 |
| Interquartile range (IQR) | 40861 |
Descriptive statistics
| Standard deviation | 28938.928 |
|---|---|
| Coefficient of variation (CV) | 0.49369473 |
| Kurtosis | -0.35977504 |
| Mean | 58617.049 |
| Median Absolute Deviation (MAD) | 4560 |
| Skewness | 0.94224283 |
| Sum | 1.8460883 × 1011 |
| Variance | 8.3746156 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 38871 | 486724 | 15.5% |
| 77884 | 54089 | 1.7% |
| 38895 | 43236 | 1.4% |
| 77886 | 34473 | 1.1% |
| 136103 | 24784 | 0.8% |
| 34141 | 18866 | 0.6% |
| 78025 | 18367 | 0.6% |
| 112769 | 18264 | 0.6% |
| 95132 | 17612 | 0.6% |
| 79104 | 17451 | 0.6% |
| Other values (1147) | 2415539 |
| Value | Count | Frequency (%) |
| 34141 | 18866 | |
| 34142 | 30 | < 0.1% |
| 34144 | 292 | < 0.1% |
| 34146 | 3510 | 0.1% |
| 34148 | 3350 | 0.1% |
| 34149 | 3257 | 0.1% |
| 34150 | 3498 | 0.1% |
| 34151 | 3451 | 0.1% |
| 34152 | 4500 | 0.1% |
| 34153 | 3450 | 0.1% |
| Value | Count | Frequency (%) |
| 142700 | 1 | < 0.1% |
| 142680 | 1 | < 0.1% |
| 142660 | 1 | < 0.1% |
| 142650 | 1 | < 0.1% |
| 142649 | 1 | < 0.1% |
| 142648 | 1 | < 0.1% |
| 142586 | 1 | < 0.1% |
| 142585 | 1 | < 0.1% |
| 142460 | 1 | < 0.1% |
| 142429 | 34 |
RFC2
Text
| Distinct | 159 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4819 |
| Missing (%) | 0.2% |
| Memory size | 24.0 MiB |
Length
| Max length | 14 |
|---|---|
| Median length | 12 |
| Mean length | 12.02099 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NFI3406305T0 |
|---|---|
| 2nd row | NFI3406305T0 |
| 3rd row | NFI3406305T0 |
| 4th row | NFI3406305T0 |
| 5th row | NFI3406305T0 |
| Value | Count | Frequency (%) |
| nfi3406305t0 | 1246565 | |
| nff030630458 | 486724 | 15.5% |
| inf7205011za | 100041 | 3.2% |
| cjf950204tl0 | 88116 | 2.8% |
| nfs030505am4 | 79433 | 2.5% |
| pac8907264g0 | 74905 | 2.4% |
| scj9502046p5 | 71261 | 2.3% |
| fda050428177 | 56888 | 1.8% |
| gec981004re5 | 52227 | 1.7% |
| nff930518f76 | 45689 | 1.5% |
| Other values (148) | 842737 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7967115 | |
| 3 | 4037485 | |
| F | 3312968 | 8.8% |
| 5 | 2873786 | 7.6% |
| 4 | 2479383 | 6.6% |
| 6 | 2252631 | 6.0% |
| N | 2189104 | 5.8% |
| I | 1558902 | 4.1% |
| T | 1442261 | 3.8% |
| 1 | 1360143 | 3.6% |
| Other values (28) | 8327258 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37801036 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7967115 | |
| 3 | 4037485 | |
| F | 3312968 | 8.8% |
| 5 | 2873786 | 7.6% |
| 4 | 2479383 | 6.6% |
| 6 | 2252631 | 6.0% |
| N | 2189104 | 5.8% |
| I | 1558902 | 4.1% |
| T | 1442261 | 3.8% |
| 1 | 1360143 | 3.6% |
| Other values (28) | 8327258 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37801036 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7967115 | |
| 3 | 4037485 | |
| F | 3312968 | 8.8% |
| 5 | 2873786 | 7.6% |
| 4 | 2479383 | 6.6% |
| 6 | 2252631 | 6.0% |
| N | 2189104 | 5.8% |
| I | 1558902 | 4.1% |
| T | 1442261 | 3.8% |
| 1 | 1360143 | 3.6% |
| Other values (28) | 8327258 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37801036 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7967115 | |
| 3 | 4037485 | |
| F | 3312968 | 8.8% |
| 5 | 2873786 | 7.6% |
| 4 | 2479383 | 6.6% |
| 6 | 2252631 | 6.0% |
| N | 2189104 | 5.8% |
| I | 1558902 | 4.1% |
| T | 1442261 | 3.8% |
| 1 | 1360143 | 3.6% |
| Other values (28) | 8327258 |
ID_TRANSACTION
Real number (ℝ)
High correlation
| Distinct | 2556663 |
|---|---|
| Distinct (%) | 81.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2256200.5 |
| Minimum | 273484 |
|---|---|
| Maximum | 4014177 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 273484 |
|---|---|
| 5-th percentile | 494106.2 |
| Q1 | 1326548 |
| median | 2300809 |
| Q3 | 3219371 |
| 95-th percentile | 3863952.8 |
| Maximum | 4014177 |
| Range | 3740693 |
| Interquartile range (IQR) | 1892823 |
Descriptive statistics
| Standard deviation | 1084586.7 |
|---|---|
| Coefficient of variation (CV) | 0.48071378 |
| Kurtosis | -1.1983944 |
| Mean | 2256200.5 |
| Median Absolute Deviation (MAD) | 945002 |
| Skewness | -0.11352217 |
| Sum | 7.1056891 × 1012 |
| Variance | 1.1763282 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3371033 | 5143 | 0.2% |
| 3371049 | 4632 | 0.1% |
| 379431 | 2296 | 0.1% |
| 381496 | 2237 | 0.1% |
| 415634 | 2185 | 0.1% |
| 353315 | 1997 | 0.1% |
| 375326 | 1747 | 0.1% |
| 399401 | 1193 | < 0.1% |
| 394432 | 1175 | < 0.1% |
| 439515 | 1098 | < 0.1% |
| Other values (2556653) | 3125702 |
| Value | Count | Frequency (%) |
| 273484 | 1 | |
| 273486 | 1 | |
| 273487 | 1 | |
| 273490 | 1 | |
| 273512 | 1 | |
| 273513 | 1 | |
| 273514 | 1 | |
| 273515 | 1 | |
| 273516 | 1 | |
| 273517 | 1 |
| Value | Count | Frequency (%) |
| 4014177 | 1 | |
| 4014176 | 1 | |
| 4014175 | 1 | |
| 4014174 | 1 | |
| 4014173 | 1 | |
| 4014172 | 1 | |
| 4014170 | 1 | |
| 4014169 | 1 | |
| 4014168 | 1 | |
| 4014167 | 1 |
FECHA_DE_ENTRADA
Date
| Distinct | 858251 |
|---|---|
| Distinct (%) | 27.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 24.0 MiB |
| Minimum | 2012-02-01 09:04:24 |
|---|---|
| Maximum | 2025-02-19 18:18:40 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
FECHA_DE_ACUERDO
Date
| Distinct | 3297 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 24.0 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2025-02-25 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Missing
| Distinct | 3291 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 90735 |
| Missing (%) | 2.9% |
| Memory size | 24.0 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2025-02-19 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
| Distinct | 3298 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 24.0 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2025-02-26 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
| Distinct | 3297 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 24.0 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2025-02-26 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
FECHA_DE_FIN_DE_TRANSACCION
Date
Missing
| Distinct | 3289 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1337566 |
| Missing (%) | 42.5% |
| Memory size | 24.0 MiB |
| Minimum | 2012-02-01 00:00:00 |
|---|---|
| Maximum | 2025-03-13 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
TASA_DE_TRANSACCION
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 8177 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 1337566 |
| Missing (%) | 42.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.9382921 |
| Minimum | 0 |
|---|---|
| Maximum | 13.155491 |
| Zeros | 57852 |
| Zeros (%) | 1.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.42 |
| Q1 | 3.71 |
| median | 5.58 |
| Q3 | 7.93 |
| 95-th percentile | 11.16 |
| Maximum | 13.155491 |
| Range | 13.155491 |
| Interquartile range (IQR) | 4.22 |
Descriptive statistics
| Standard deviation | 2.9756611 |
|---|---|
| Coefficient of variation (CV) | 0.50109712 |
| Kurtosis | -0.74786996 |
| Mean | 5.9382921 |
| Median Absolute Deviation (MAD) | 2.11 |
| Skewness | 0.16770335 |
| Sum | 10759229 |
| Variance | 8.8545587 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 57852 | 1.8% |
| 4.45 | 35708 | 1.1% |
| 11.16 | 34533 | 1.1% |
| 3.96 | 34361 | 1.1% |
| 2.93 | 31363 | 1.0% |
| 2.92 | 29487 | 0.9% |
| 2.94 | 27540 | 0.9% |
| 4.44 | 22970 | 0.7% |
| 4.43 | 20836 | 0.7% |
| 11.18 | 19786 | 0.6% |
| Other values (8167) | 1497403 | |
| (Missing) | 1337566 |
| Value | Count | Frequency (%) |
| 0 | 57852 | |
| 1 × 10-5 | 103 | < 0.1% |
| 0.0005 | 71 | < 0.1% |
| 0.001 | 1 | < 0.1% |
| 0.005 | 1 | < 0.1% |
| 0.00694675 | 1 | < 0.1% |
| 0.00695692 | 1 | < 0.1% |
| 0.00695695 | 1 | < 0.1% |
| 0.00695774 | 1 | < 0.1% |
| 0.00695778 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13.15549059 | 1 | |
| 12.8113879 | 1 | |
| 12.79090425 | 1 | |
| 12.67605634 | 1 | |
| 12.60283564 | 1 | |
| 12.45531081 | 1 | |
| 12.45028532 | 1 | |
| 12.40844464 | 1 | |
| 12.40416918 | 1 | |
| 12.35521236 | 1 |
COMENTARIOS_TX
Text
Missing
| Distinct | 189795 |
|---|---|
| Distinct (%) | 23.6% |
| Missing | 2346822 |
| Missing (%) | 74.5% |
| Memory size | 24.0 MiB |
Length
| Max length | 500 |
|---|---|
| Median length | 470 |
| Mean length | 155.17816 |
| Min length | 1 |
Unique
| Unique | 172981 ? |
|---|---|
| Unique (%) | 21.6% |
Sample
| 1st row | REGISTRAR EN 1317-2-2 ENTE 357 NAFIN/FIDE ELECTRODOMESTICOS POR VENCIMIENTOS NO PAGADOS DEL 1/02/2012 DE TERCEROS NAFIN BANCA PRIMER PISO AUTORIZACION COMITE DEL 2-JUL-08 |
|---|---|
| 2nd row | saldo inicial prueba piloto |
| 3rd row | PAGO DE GARANTIAS / AUT SES COM 020708 PAGO DE CONTRAGARANTIA AL FISO 11480 X GTIA PAG 1317-2-2-148 BANORTE FH 070212 CTO 1064277 DE BENEFICIARIO NINGUNO |
| 4th row | PAGO DE GARANTIAS / RETIRO DE ACREEDORES DIVERSOS DE SANTANDER 2106-02-90-149 CTO 1064080 DE BENEFICIARIO NINGUNA |
| 5th row | ENTREGA DE INTERESER A TERCEROS / AUT SESION COMITE DEL 02-JUL-08 PAGO NAFIN POR SUBSIDIO DE TASA DEL PROGRAMA EMERGENTE TABASCO DE FET ABONO A CTA 2351-3 DE TERCERO NACIONAL FINANCIERA, S.N.C. - GARANTIAS |
| Value | Count | Frequency (%) |
| de | 1485881 | 8.6% |
| por | 663893 | 3.8% |
| pago | 657225 | 3.8% |
| gasto | 465986 | 2.7% |
| servicios | 455289 | 2.6% |
| del | 452120 | 2.6% |
| médico | 412572 | 2.4% |
| solicitudes | 402516 | 2.3% |
| regionales | 401941 | 2.3% |
| transf | 396924 | 2.3% |
| Other values (173170) | 11511558 |
Most occurring characters
| Value | Count | Frequency (%) |
| 16726467 | 13.4% | |
| o | 8072680 | 6.5% |
| e | 6553557 | 5.3% |
| a | 5899582 | 4.7% |
| i | 5769202 | 4.6% |
| s | 5748052 | 4.6% |
| r | 4509452 | 3.6% |
| n | 3700448 | 3.0% |
| d | 3661617 | 2.9% |
| E | 3434289 | 2.8% |
| Other values (122) | 60468008 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 124543354 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 16726467 | 13.4% | |
| o | 8072680 | 6.5% |
| e | 6553557 | 5.3% |
| a | 5899582 | 4.7% |
| i | 5769202 | 4.6% |
| s | 5748052 | 4.6% |
| r | 4509452 | 3.6% |
| n | 3700448 | 3.0% |
| d | 3661617 | 2.9% |
| E | 3434289 | 2.8% |
| Other values (122) | 60468008 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 124543354 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 16726467 | 13.4% | |
| o | 8072680 | 6.5% |
| e | 6553557 | 5.3% |
| a | 5899582 | 4.7% |
| i | 5769202 | 4.6% |
| s | 5748052 | 4.6% |
| r | 4509452 | 3.6% |
| n | 3700448 | 3.0% |
| d | 3661617 | 2.9% |
| E | 3434289 | 2.8% |
| Other values (122) | 60468008 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 124543354 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 16726467 | 13.4% | |
| o | 8072680 | 6.5% |
| e | 6553557 | 5.3% |
| a | 5899582 | 4.7% |
| i | 5769202 | 4.6% |
| s | 5748052 | 4.6% |
| r | 4509452 | 3.6% |
| n | 3700448 | 3.0% |
| d | 3661617 | 2.9% |
| E | 3434289 | 2.8% |
| Other values (122) | 60468008 |
CONCEPTO_TX
Text
Missing
| Distinct | 109 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2347232 |
| Missing (%) | 74.5% |
| Memory size | 24.0 MiB |
Length
| Max length | 63 |
|---|---|
| Median length | 19 |
| Mean length | 22.794999 |
| Min length | 6 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 235123 |
|---|---|
| 2nd row | APORTACION A PATRIMONIO 2351 |
| 3rd row | APORTACION A PATRIMONIO 2351 |
| 4th row | APORTACION A PATRIMONIO 2351 |
| 5th row | PAGO DE GARANTIAS SIN COMISION E IVA |
| Value | Count | Frequency (%) |
| entrega | 480918 | |
| patrimonial | 457221 | |
| de | 270070 | |
| pago | 209347 | |
| acreedores | 152777 | 6.3% |
| diversos | 152666 | 6.3% |
| a | 52182 | 2.1% |
| e | 50195 | 2.1% |
| patrimonio | 47465 | 2.0% |
| iva | 47190 | 1.9% |
| Other values (164) | 508597 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 2226260 | |
| E | 2187780 | |
| R | 1710180 | |
| 1668085 | ||
| I | 1577334 | |
| O | 1486949 | |
| N | 1245854 | 6.8% |
| T | 1199766 | 6.6% |
| P | 892494 | 4.9% |
| S | 817324 | 4.5% |
| Other values (26) | 3273507 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 18285533 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 2226260 | |
| E | 2187780 | |
| R | 1710180 | |
| 1668085 | ||
| I | 1577334 | |
| O | 1486949 | |
| N | 1245854 | 6.8% |
| T | 1199766 | 6.6% |
| P | 892494 | 4.9% |
| S | 817324 | 4.5% |
| Other values (26) | 3273507 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 18285533 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 2226260 | |
| E | 2187780 | |
| R | 1710180 | |
| 1668085 | ||
| I | 1577334 | |
| O | 1486949 | |
| N | 1245854 | 6.8% |
| T | 1199766 | 6.6% |
| P | 892494 | 4.9% |
| S | 817324 | 4.5% |
| Other values (26) | 3273507 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 18285533 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 2226260 | |
| E | 2187780 | |
| R | 1710180 | |
| 1668085 | ||
| I | 1577334 | |
| O | 1486949 | |
| N | 1245854 | 6.8% |
| T | 1199766 | 6.6% |
| P | 892494 | 4.9% |
| S | 817324 | 4.5% |
| Other values (26) | 3273507 |
OBJETIVO_DEL_FIDEICOMISO
Real number (ℝ)
High correlation Missing
| Distinct | 430 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 2983785 |
| Missing (%) | 94.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4067.9786 |
| Minimum | 1613 |
|---|---|
| Maximum | 6733 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 1613 |
|---|---|
| 5-th percentile | 2927 |
| Q1 | 2928 |
| median | 3384 |
| Q3 | 5727 |
| 95-th percentile | 6148 |
| Maximum | 6733 |
| Range | 5120 |
| Interquartile range (IQR) | 2799 |
Descriptive statistics
| Standard deviation | 1210.9652 |
|---|---|
| Coefficient of variation (CV) | 0.2976823 |
| Kurtosis | -1.08985 |
| Mean | 4067.9786 |
| Median Absolute Deviation (MAD) | 457 |
| Skewness | 0.592351 |
| Sum | 6.7373861 × 108 |
| Variance | 1466436.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2928 | 32182 | 1.0% |
| 5727 | 31204 | 1.0% |
| 3373 | 22956 | 0.7% |
| 3384 | 13990 | 0.4% |
| 6148 | 8934 | 0.3% |
| 4179 | 8555 | 0.3% |
| 2927 | 5593 | 0.2% |
| 4048 | 3669 | 0.1% |
| 4397 | 3056 | 0.1% |
| 3368 | 2884 | 0.1% |
| Other values (420) | 32597 | 1.0% |
| (Missing) | 2983785 |
| Value | Count | Frequency (%) |
| 1613 | 312 | |
| 1616 | 1 | < 0.1% |
| 1617 | 258 | |
| 1618 | 4 | < 0.1% |
| 1739 | 1 | < 0.1% |
| 1853 | 73 | < 0.1% |
| 1854 | 1 | < 0.1% |
| 1872 | 27 | < 0.1% |
| 1876 | 5 | < 0.1% |
| 1877 | 105 | < 0.1% |
| Value | Count | Frequency (%) |
| 6733 | 1 | < 0.1% |
| 6732 | 3 | |
| 6731 | 2 | |
| 6727 | 1 | < 0.1% |
| 6722 | 1 | < 0.1% |
| 6721 | 2 | |
| 6717 | 1 | < 0.1% |
| 6716 | 1 | < 0.1% |
| 6711 | 1 | < 0.1% |
| 6710 | 1 | < 0.1% |
SUBTIPO_TX
Categorical
High correlation Imbalance Missing
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2168606 |
| Missing (%) | 68.9% |
| Memory size | 24.0 MiB |
| CORTO PLAZO | |
|---|---|
| Conciliación SIFC - TAS | |
| Pago de honorarios con cargo al patrimonio | 8051 |
| Pago de honorarios con depósito del cliente | 4819 |
| LARGO PLAZO | 2172 |
Length
| Max length | 43 |
|---|---|
| Median length | 11 |
| Mean length | 13.396446 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CORTO PLAZO |
|---|---|
| 2nd row | CORTO PLAZO |
| 3rd row | CORTO PLAZO |
| 4th row | CORTO PLAZO |
| 5th row | CORTO PLAZO |
Common Values
| Value | Count | Frequency (%) |
| CORTO PLAZO | 803541 | 25.5% |
| Conciliación SIFC - TAS | 162199 | 5.2% |
| Pago de honorarios con cargo al patrimonio | 8051 | 0.3% |
| Pago de honorarios con depósito del cliente | 4819 | 0.2% |
| LARGO PLAZO | 2172 | 0.1% |
| Inicialización de Acuerdos | 17 | < 0.1% |
| (Missing) | 2168606 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| plazo | 805713 | |
| corto | 803541 | |
| conciliación | 162199 | 6.9% |
| sifc | 162199 | 6.9% |
| 162199 | 6.9% | |
| tas | 162199 | 6.9% |
| de | 12887 | 0.5% |
| honorarios | 12870 | 0.5% |
| con | 12870 | 0.5% |
| pago | 12870 | 0.5% |
| Other values (9) | 40816 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 2414967 | |
| 1369564 | ||
| C | 1127939 | |
| A | 970101 | 7.4% |
| T | 965740 | 7.4% |
| P | 818583 | 6.2% |
| L | 807885 | 6.1% |
| R | 805713 | 6.1% |
| Z | 805713 | 6.1% |
| i | 525275 | 4.0% |
| Other values (22) | 2527741 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 13139221 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| O | 2414967 | |
| 1369564 | ||
| C | 1127939 | |
| A | 970101 | 7.4% |
| T | 965740 | 7.4% |
| P | 818583 | 6.2% |
| L | 807885 | 6.1% |
| R | 805713 | 6.1% |
| Z | 805713 | 6.1% |
| i | 525275 | 4.0% |
| Other values (22) | 2527741 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 13139221 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| O | 2414967 | |
| 1369564 | ||
| C | 1127939 | |
| A | 970101 | 7.4% |
| T | 965740 | 7.4% |
| P | 818583 | 6.2% |
| L | 807885 | 6.1% |
| R | 805713 | 6.1% |
| Z | 805713 | 6.1% |
| i | 525275 | 4.0% |
| Other values (22) | 2527741 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 13139221 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| O | 2414967 | |
| 1369564 | ||
| C | 1127939 | |
| A | 970101 | 7.4% |
| T | 965740 | 7.4% |
| P | 818583 | 6.2% |
| L | 807885 | 6.1% |
| R | 805713 | 6.1% |
| Z | 805713 | 6.1% |
| i | 525275 | 4.0% |
| Other values (22) | 2527741 |
MONTO_DE_COMISIONES
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 253 |
| Missing (%) | < 0.1% |
| Memory size | 24.0 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 3149152 | |
| (Missing) | 253 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 3149152 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6298304 | |
| . | 3149152 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9447456 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6298304 | |
| . | 3149152 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9447456 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6298304 | |
| . | 3149152 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9447456 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6298304 | |
| . | 3149152 |
INTERES_LIMPIO_FUTURO
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2799144 |
| Missing (%) | 88.9% |
| Memory size | 24.0 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 350261 | 11.1% |
| (Missing) | 2799144 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 350261 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 700522 | |
| . | 350261 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1050783 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 700522 | |
| . | 350261 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1050783 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 700522 | |
| . | 350261 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1050783 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 700522 | |
| . | 350261 |
EXCEDENTE_UTILIZADO
Unsupported
Missing Rejected Unsupported
| Missing | 3149405 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 24.0 MiB |
MONTO_EN_DOLARES
Unsupported
Missing Rejected Unsupported
| Missing | 3149405 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 24.0 MiB |
TASA_DE_CAMBIO_DOLARES
Unsupported
Missing Rejected Unsupported
| Missing | 3149405 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 24.0 MiB |
MONTO_SERIE_PRI
Real number (ℝ)
High correlation Skewed
| Distinct | 390508 |
|---|---|
| Distinct (%) | 12.4% |
| Missing | 253 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2480874.4 |
| Minimum | 0 |
|---|---|
| Maximum | 6.0876246 × 1010 |
| Zeros | 4591 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.05 |
| Q1 | 1 |
| median | 1 |
| Q3 | 346246.14 |
| 95-th percentile | 8854747.8 |
| Maximum | 6.0876246 × 1010 |
| Range | 6.0876246 × 1010 |
| Interquartile range (IQR) | 346245.14 |
Descriptive statistics
| Standard deviation | 88743588 |
|---|---|
| Coefficient of variation (CV) | 35.771093 |
| Kurtosis | 163140.03 |
| Mean | 2480874.4 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 323.47417 |
| Sum | 7.8126505 × 1012 |
| Variance | 7.8754245 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1812407 | |
| 0.01 | 82995 | 2.6% |
| 0.02 | 13121 | 0.4% |
| 500000 | 6923 | 0.2% |
| 2500000 | 5741 | 0.2% |
| 0.03 | 5559 | 0.2% |
| 65010350.19 | 5143 | 0.2% |
| 0.04 | 4900 | 0.2% |
| 3900586.55 | 4632 | 0.1% |
| 0 | 4591 | 0.1% |
| Other values (390498) | 1203140 |
| Value | Count | Frequency (%) |
| 0 | 4591 | |
| 1 × 10-8 | 67 | < 0.1% |
| 2 × 10-8 | 105 | < 0.1% |
| 3 × 10-8 | 87 | < 0.1% |
| 4 × 10-8 | 121 | < 0.1% |
| 5 × 10-8 | 60 | < 0.1% |
| 6 × 10-8 | 26 | < 0.1% |
| 7 × 10-8 | 1 | < 0.1% |
| 8 × 10-8 | 10 | < 0.1% |
| 1 × 10-7 | 22 | < 0.1% |
| Value | Count | Frequency (%) |
| 6.087624637 × 1010 | 1 | |
| 5.685641939 × 1010 | 1 | |
| 3.724352732 × 1010 | 2 | |
| 3 × 1010 | 1 | |
| 2.93310911 × 1010 | 1 | |
| 2.6411527 × 1010 | 1 | |
| 2.467502145 × 1010 | 1 | |
| 2.4 × 1010 | 1 | |
| 1.794 × 1010 | 1 | |
| 1.759005459 × 1010 | 1 |
MONTO_BRUTO
Real number (ℝ)
High correlation Missing
| Distinct | 347333 |
|---|---|
| Distinct (%) | 98.4% |
| Missing | 2796429 |
| Missing (%) | 88.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2250991 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 1.5306514 × 1010 |
| Zeros | 58 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 11950.24 |
| Q1 | 2231941.8 |
| median | 19284083 |
| Q3 | 1.7142202 × 108 |
| 95-th percentile | 1.055554 × 109 |
| Maximum | 1.5306514 × 1010 |
| Range | 1.5306514 × 1010 |
| Interquartile range (IQR) | 1.6919007 × 108 |
Descriptive statistics
| Standard deviation | 5.8542822 × 108 |
|---|---|
| Coefficient of variation (CV) | 2.6310208 |
| Kurtosis | 50.313771 |
| Mean | 2.2250991 × 108 |
| Median Absolute Deviation (MAD) | 19234044 |
| Skewness | 5.9397455 |
| Sum | 7.854066 × 1013 |
| Variance | 3.427262 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 58 | < 0.1% |
| 99.46 | 34 | < 0.1% |
| 99.52 | 31 | < 0.1% |
| 99.88 | 27 | < 0.1% |
| 99.98 | 25 | < 0.1% |
| 100.26 | 23 | < 0.1% |
| 99.96 | 23 | < 0.1% |
| 99.99 | 23 | < 0.1% |
| 100.13 | 23 | < 0.1% |
| 100.09 | 22 | < 0.1% |
| Other values (347323) | 352687 | 11.2% |
| (Missing) | 2796429 |
| Value | Count | Frequency (%) |
| 0 | 58 | |
| 19.54 | 1 | < 0.1% |
| 48.19 | 1 | < 0.1% |
| 68.15 | 1 | < 0.1% |
| 76.08 | 1 | < 0.1% |
| 78.68 | 1 | < 0.1% |
| 79.68 | 1 | < 0.1% |
| 81.47 | 1 | < 0.1% |
| 81.98 | 1 | < 0.1% |
| 83.06 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.530651398 × 1010 | 1 | |
| 1.149335468 × 1010 | 1 | |
| 1.148472497 × 1010 | 1 | |
| 1.146398509 × 1010 | 1 | |
| 1.144696441 × 1010 | 1 | |
| 1.14263681 × 1010 | 1 | |
| 1.068098806 × 1010 | 1 | |
| 1.06455167 × 1010 | 1 | |
| 9899999983 | 1 | |
| 9899999952 | 1 |
MONTO_ORDENADO
Real number (ℝ)
High correlation Missing
| Distinct | 1875 |
|---|---|
| Distinct (%) | 68.7% |
| Missing | 3146676 |
| Missing (%) | 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14277963 |
| Minimum | 0 |
|---|---|
| Maximum | 3.0146884 × 109 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 707.072 |
| Q1 | 10560 |
| median | 65564 |
| Q3 | 363622.91 |
| 95-th percentile | 9560088.2 |
| Maximum | 3.0146884 × 109 |
| Range | 3.0146884 × 109 |
| Interquartile range (IQR) | 353062.91 |
Descriptive statistics
| Standard deviation | 1.3330314 × 108 |
|---|---|
| Coefficient of variation (CV) | 9.3362856 |
| Kurtosis | 259.97368 |
| Mean | 14277963 |
| Median Absolute Deviation (MAD) | 64364 |
| Skewness | 14.645131 |
| Sum | 3.8964562 × 1010 |
| Variance | 1.7769728 × 1016 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10000 | 23 | < 0.1% |
| 50000 | 18 | < 0.1% |
| 3427.8 | 18 | < 0.1% |
| 3638.92 | 16 | < 0.1% |
| 100000 | 16 | < 0.1% |
| 712.71 | 14 | < 0.1% |
| 1097.15 | 13 | < 0.1% |
| 10587.5 | 13 | < 0.1% |
| 20114.43 | 13 | < 0.1% |
| 13066.43 | 13 | < 0.1% |
| Other values (1865) | 2572 | 0.1% |
| (Missing) | 3146676 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 0.01 | 1 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.07 | 3 | < 0.1% |
| 1 | 8 | |
| 1.4 | 1 | < 0.1% |
| 10 | 5 | |
| 11 | 1 | < 0.1% |
| 16 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3014688352 | 1 | |
| 3014688352 | 1 | |
| 2269060503 | 1 | |
| 1809727100 | 1 | |
| 1444601261 | 1 | |
| 1431330981 | 1 | |
| 1410378506 | 2 | |
| 1244586711 | 2 | |
| 1192070325 | 1 | |
| 983850662.7 | 1 |
ID_DISPERSION
Real number (ℝ)
High correlation Missing
| Distinct | 602656 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 2546749 |
| Missing (%) | 80.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 309215.89 |
| Minimum | 1 |
|---|---|
| Maximum | 623592 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 30133.75 |
| Q1 | 152012.75 |
| median | 310160.5 |
| Q3 | 463934.25 |
| 95-th percentile | 593221.25 |
| Maximum | 623592 |
| Range | 623591 |
| Interquartile range (IQR) | 311921.5 |
Descriptive statistics
| Standard deviation | 179975.83 |
|---|---|
| Coefficient of variation (CV) | 0.58203939 |
| Kurtosis | -1.197351 |
| Mean | 309215.89 |
| Median Absolute Deviation (MAD) | 155955 |
| Skewness | 0.0080813692 |
| Sum | 1.8635081 × 1011 |
| Variance | 3.2391299 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 413455 | 1 | < 0.1% |
| 413438 | 1 | < 0.1% |
| 413439 | 1 | < 0.1% |
| 413440 | 1 | < 0.1% |
| 413441 | 1 | < 0.1% |
| 413442 | 1 | < 0.1% |
| 413443 | 1 | < 0.1% |
| 413444 | 1 | < 0.1% |
| 413445 | 1 | < 0.1% |
| 413446 | 1 | < 0.1% |
| Other values (602646) | 602646 | 19.1% |
| (Missing) | 2546749 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 623592 | 1 | |
| 623591 | 1 | |
| 623590 | 1 | |
| 623589 | 1 | |
| 623588 | 1 | |
| 623587 | 1 | |
| 623586 | 1 | |
| 623585 | 1 | |
| 623584 | 1 | |
| 623583 | 1 |
MONTO_DISPERSION
Real number (ℝ)
High correlation Missing Skewed
| Distinct | 235350 |
|---|---|
| Distinct (%) | 39.1% |
| Missing | 2546749 |
| Missing (%) | 80.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42206.905 |
| Minimum | 0.2 |
|---|---|
| Maximum | 40000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.0 MiB |
Quantile statistics
| Minimum | 0.2 |
|---|---|
| 5-th percentile | 413.97 |
| Q1 | 2274.33 |
| median | 5133.69 |
| Q3 | 19061.147 |
| 95-th percentile | 108627.82 |
| Maximum | 40000000 |
| Range | 40000000 |
| Interquartile range (IQR) | 16786.817 |
Descriptive statistics
| Standard deviation | 284137.24 |
|---|---|
| Coefficient of variation (CV) | 6.7320085 |
| Kurtosis | 3323.9535 |
| Mean | 42206.905 |
| Median Absolute Deviation (MAD) | 4017.69 |
| Skewness | 40.465184 |
| Sum | 2.5436245 × 1010 |
| Variance | 8.0733974 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5000 | 25842 | 0.8% |
| 50000 | 8626 | 0.3% |
| 2317.5 | 6099 | 0.2% |
| 40000 | 4865 | 0.2% |
| 4765.5 | 4372 | 0.1% |
| 80000 | 3750 | 0.1% |
| 5989.5 | 3648 | 0.1% |
| 5308.51 | 3433 | 0.1% |
| 2654.25 | 2928 | 0.1% |
| 7213.5 | 2835 | 0.1% |
| Other values (235340) | 536258 | 17.0% |
| (Missing) | 2546749 |
| Value | Count | Frequency (%) |
| 0.2 | 1 | < 0.1% |
| 0.58 | 46 | |
| 1 | 22 | < 0.1% |
| 1.16 | 63 | |
| 1.28 | 1 | < 0.1% |
| 1.37 | 1 | < 0.1% |
| 1.38 | 1 | < 0.1% |
| 1.46 | 2 | < 0.1% |
| 1.54 | 1 | < 0.1% |
| 1.74 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40000000 | 1 | |
| 39013800 | 1 | |
| 32493121.27 | 1 | |
| 31230000 | 1 | |
| 30000000 | 2 | |
| 27424740 | 1 | |
| 25091250 | 1 | |
| 24305000 | 1 | |
| 23623533.97 | 1 | |
| 22495931 | 1 |
Missing
| Distinct | 37387 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 2546749 |
| Missing (%) | 80.9% |
| Memory size | 24.0 MiB |
Length
| Max length | 90 |
|---|---|
| Median length | 85 |
| Mean length | 27.111063 |
| Min length | 6 |
Unique
| Unique | 17700 ? |
|---|---|
| Unique (%) | 2.9% |
Sample
| 1st row | FARMACIAS ABC DE MEXICO SA DE |
|---|---|
| 2nd row | FARMACIAS ABC DE MEXICO SA DE |
| 3rd row | FARMACIAS ABC DE MEXICO SA DE |
| 4th row | FARMACIAS ABC DE MEXICO SA DE |
| 5th row | FARMACIAS ABC DE MEXICO SA DE |
| Value | Count | Frequency (%) |
| de | 287519 | 11.1% |
| sa | 147745 | 5.7% |
| cv | 140399 | 5.4% |
| farmacias | 45823 | 1.8% |
| hospitales | 45389 | 1.8% |
| operadora | 44715 | 1.7% |
| angele | 40230 | 1.6% |
| medica | 31503 | 1.2% |
| maria | 31443 | 1.2% |
| benavides | 30400 | 1.2% |
| Other values (13759) | 1744896 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 2197274 | |
| 1991598 | ||
| E | 1619366 | |
| R | 1196150 | 7.3% |
| O | 1115568 | 6.8% |
| I | 1017956 | 6.2% |
| S | 975507 | 6.0% |
| D | 760811 | 4.7% |
| L | 736129 | 4.5% |
| N | 721280 | 4.4% |
| Other values (86) | 4007006 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16338645 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 2197274 | |
| 1991598 | ||
| E | 1619366 | |
| R | 1196150 | 7.3% |
| O | 1115568 | 6.8% |
| I | 1017956 | 6.2% |
| S | 975507 | 6.0% |
| D | 760811 | 4.7% |
| L | 736129 | 4.5% |
| N | 721280 | 4.4% |
| Other values (86) | 4007006 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16338645 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 2197274 | |
| 1991598 | ||
| E | 1619366 | |
| R | 1196150 | 7.3% |
| O | 1115568 | 6.8% |
| I | 1017956 | 6.2% |
| S | 975507 | 6.0% |
| D | 760811 | 4.7% |
| L | 736129 | 4.5% |
| N | 721280 | 4.4% |
| Other values (86) | 4007006 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16338645 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 2197274 | |
| 1991598 | ||
| E | 1619366 | |
| R | 1196150 | 7.3% |
| O | 1115568 | 6.8% |
| I | 1017956 | 6.2% |
| S | 975507 | 6.0% |
| D | 760811 | 4.7% |
| L | 736129 | 4.5% |
| N | 721280 | 4.4% |
| Other values (86) | 4007006 |
RFC_BENEFICIARIO
Text
Missing
| Distinct | 35999 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 2546749 |
| Missing (%) | 80.9% |
| Memory size | 24.0 MiB |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 12.56618 |
| Min length | 10 |
Unique
| Unique | 17273 ? |
|---|---|
| Unique (%) | 2.9% |
Sample
| 1st row | FAB8412112X2 |
|---|---|
| 2nd row | FAB8412112X2 |
| 3rd row | FAB8412112X2 |
| 4th row | FAB8412112X2 |
| 5th row | FAB8412112X2 |
| Value | Count | Frequency (%) |
| oha051017ke7 | 44101 | 7.3% |
| fbe9110215z3 | 30292 | 5.0% |
| sme001012ri2 | 23563 | 3.9% |
| shm9610301fa | 7400 | 1.2% |
| inf891031lt4 | 6556 | 1.1% |
| far970429se2 | 5634 | 0.9% |
| def920101uya | 4527 | 0.8% |
| cfa930628et2 | 4149 | 0.7% |
| fra900718daa | 3968 | 0.7% |
| amr901112qc7 | 3912 | 0.6% |
| Other values (35994) | 468909 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 945797 | 12.5% |
| 1 | 825962 | 10.9% |
| 2 | 498030 | 6.6% |
| A | 404772 | 5.3% |
| 5 | 377547 | 5.0% |
| 7 | 364386 | 4.8% |
| 9 | 319689 | 4.2% |
| 3 | 295934 | 3.9% |
| 8 | 289119 | 3.8% |
| 4 | 275775 | 3.6% |
| Other values (32) | 2976073 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7573084 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 945797 | 12.5% |
| 1 | 825962 | 10.9% |
| 2 | 498030 | 6.6% |
| A | 404772 | 5.3% |
| 5 | 377547 | 5.0% |
| 7 | 364386 | 4.8% |
| 9 | 319689 | 4.2% |
| 3 | 295934 | 3.9% |
| 8 | 289119 | 3.8% |
| 4 | 275775 | 3.6% |
| Other values (32) | 2976073 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7573084 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 945797 | 12.5% |
| 1 | 825962 | 10.9% |
| 2 | 498030 | 6.6% |
| A | 404772 | 5.3% |
| 5 | 377547 | 5.0% |
| 7 | 364386 | 4.8% |
| 9 | 319689 | 4.2% |
| 3 | 295934 | 3.9% |
| 8 | 289119 | 3.8% |
| 4 | 275775 | 3.6% |
| Other values (32) | 2976073 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7573084 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 945797 | 12.5% |
| 1 | 825962 | 10.9% |
| 2 | 498030 | 6.6% |
| A | 404772 | 5.3% |
| 5 | 377547 | 5.0% |
| 7 | 364386 | 4.8% |
| 9 | 319689 | 4.2% |
| 3 | 295934 | 3.9% |
| 8 | 289119 | 3.8% |
| 4 | 275775 | 3.6% |
| Other values (32) | 2976073 |
Interactions
Correlations
| CUSTOMER_ID | ID_DISPERSION | ID_TRANSACTION | MONTO_BRUTO | MONTO_DISPERSION | MONTO_ORDENADO | MONTO_SERIE_PRI | OBJETIVO_DEL_FIDEICOMISO | OID_ACCOUNTS | OID_CUSTOMERS | RFC | SUBTIPO_TX | TASA_DE_TRANSACCION | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CUSTOMER_ID | 1.000 | 0.389 | 0.110 | 0.085 | 0.074 | 0.142 | 0.356 | 0.697 | 0.400 | 0.775 | 0.026 | 0.045 | -0.063 |
| ID_DISPERSION | 0.389 | 1.000 | 1.000 | NaN | 0.022 | NaN | -0.248 | 0.261 | 0.393 | 0.389 | 0.495 | 0.097 | NaN |
| ID_TRANSACTION | 0.110 | 1.000 | 1.000 | -0.199 | 0.022 | -0.153 | -0.110 | 0.512 | 0.335 | 0.104 | 0.110 | 0.130 | 0.656 |
| MONTO_BRUTO | 0.085 | NaN | -0.199 | 1.000 | NaN | NaN | 0.958 | NaN | 0.056 | 0.079 | 0.118 | 1.000 | NaN |
| MONTO_DISPERSION | 0.074 | 0.022 | 0.022 | NaN | 1.000 | NaN | 0.341 | 0.613 | 0.064 | 0.074 | 0.002 | 0.000 | NaN |
| MONTO_ORDENADO | 0.142 | NaN | -0.153 | NaN | NaN | 1.000 | 0.878 | NaN | -0.207 | 0.142 | 0.078 | 1.000 | NaN |
| MONTO_SERIE_PRI | 0.356 | -0.248 | -0.110 | 0.958 | 0.341 | 0.878 | 1.000 | 0.274 | 0.077 | 0.406 | 0.014 | 0.007 | -0.025 |
| OBJETIVO_DEL_FIDEICOMISO | 0.697 | 0.261 | 0.512 | NaN | 0.613 | NaN | 0.274 | 1.000 | 0.207 | 0.703 | 0.216 | 0.369 | NaN |
| OID_ACCOUNTS | 0.400 | 0.393 | 0.335 | 0.056 | 0.064 | -0.207 | 0.077 | 0.207 | 1.000 | 0.405 | 0.385 | 0.189 | 0.169 |
| OID_CUSTOMERS | 0.775 | 0.389 | 0.104 | 0.079 | 0.074 | 0.142 | 0.406 | 0.703 | 0.405 | 1.000 | 0.357 | 0.205 | -0.134 |
| RFC | 0.026 | 0.495 | 0.110 | 0.118 | 0.002 | 0.078 | 0.014 | 0.216 | 0.385 | 0.357 | 1.000 | 0.067 | 0.054 |
| SUBTIPO_TX | 0.045 | 0.097 | 0.130 | 1.000 | 0.000 | 1.000 | 0.007 | 0.369 | 0.189 | 0.205 | 0.067 | 1.000 | 0.000 |
| TASA_DE_TRANSACCION | -0.063 | NaN | 0.656 | NaN | NaN | NaN | -0.025 | NaN | 0.169 | -0.134 | 0.054 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| OID_CUSTOMERS | CUSTOMER_ID | LEGAL_NAME | DESCRIPTION | RFC | ADDRESS_DUMP | OID_ACCOUNTS | RFC2 | ID_TRANSACTION | FECHA_DE_ENTRADA | FECHA_DE_ACUERDO | FECHA_DE_LIQUIDACION | FECHA_DE_ACUERDO_SERIE_PRI | FECHA_DE_ACUERDO_SERIE_SEC | FECHA_DE_FIN_DE_TRANSACCION | TASA_DE_TRANSACCION | COMENTARIOS_TX | CONCEPTO_TX | OBJETIVO_DEL_FIDEICOMISO | SUBTIPO_TX | MONTO_DE_COMISIONES | INTERES_LIMPIO_FUTURO | EXCEDENTE_UTILIZADO | MONTO_EN_DOLARES | TASA_DE_CAMBIO_DOLARES | MONTO_SERIE_PRI | MONTO_BRUTO | MONTO_ORDENADO | ID_DISPERSION | MONTO_DISPERSION | NOMBRE_DE_BENEFICIARIO | RFC_BENEFICIARIO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 3091 | 80139 | Fideicomiso de Contragarantia para el Financiamiento Empresarial | Fideicomiso de Contragarantia para el Financiamiento Empresarial | XXXXXXXXXXXXX | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| | 34323 | NFI3406305T0 | 273484 | 2012-02-01 11:31:17 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | NaN | NaN | REGISTRAR EN 1317-2-2 ENTE 357 NAFIN/FIDE ELECTRODOMESTICOS POR VENCIMIENTOS NO PAGADOS DEL 1/02/2012 DE TERCEROS NAFIN BANCA PRIMER PISO AUTORIZACION COMITE DEL 2-JUL-08\r\n\r\n | 235123 | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 9.975076e+05 | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 3091 | 80139 | Fideicomiso de Contragarantia para el Financiamiento Empresarial | Fideicomiso de Contragarantia para el Financiamiento Empresarial | XXXXXXXXXXXXX | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| | 34355 | NFI3406305T0 | 273486 | 2012-02-01 14:59:26 | 2012-02-01 00:00:00 | NaN | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | NaN | NaN | saldo inicial prueba piloto | APORTACION A PATRIMONIO 2351 | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 1.788668e+05 | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 3091 | 80139 | Fideicomiso de Contragarantia para el Financiamiento Empresarial | Fideicomiso de Contragarantia para el Financiamiento Empresarial | XXXXXXXXXXXXX | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| | 34323 | NFI3406305T0 | 273487 | 2012-02-01 15:01:11 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | NaN | NaN | NaN | APORTACION A PATRIMONIO 2351 | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 2.271006e+08 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 3091 | 80139 | Fideicomiso de Contragarantia para el Financiamiento Empresarial | Fideicomiso de Contragarantia para el Financiamiento Empresarial | XXXXXXXXXXXXX | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| | 34355 | NFI3406305T0 | 273490 | 2012-02-01 15:12:31 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | NaN | NaN | NaN | APORTACION A PATRIMONIO 2351 | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 1.788668e+05 | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | 3091 | 80139 | Fideicomiso de Contragarantia para el Financiamiento Empresarial | Fideicomiso de Contragarantia para el Financiamiento Empresarial | XXXXXXXXXXXXX | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| | 34376 | NFI3406305T0 | 273814 | 2012-02-01 14:03:37 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | NaN | NaN | PAGO DE GARANTIAS / AUT SES COM 020708 PAGO DE CONTRAGARANTIA AL FISO 11480 X GTIA PAG 1317-2-2-148 BANORTE FH 070212 CTO 1064277 DE BENEFICIARIO NINGUNO | PAGO DE GARANTIAS SIN COMISION E IVA | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 2.380695e+06 | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | 3091 | 80139 | Fideicomiso de Contragarantia para el Financiamiento Empresarial | Fideicomiso de Contragarantia para el Financiamiento Empresarial | XXXXXXXXXXXXX | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| | 34329 | NFI3406305T0 | 273816 | 2012-02-01 14:08:06 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | NaN | NaN | PAGO DE GARANTIAS / RETIRO DE ACREEDORES DIVERSOS DE SANTANDER 2106-02-90-149 CTO 1064080 DE BENEFICIARIO NINGUNA | PAGO DE GARANTIAS SIN COMISION E IVA | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 1.306274e+04 | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | 3091 | 80139 | Fideicomiso de Contragarantia para el Financiamiento Empresarial | Fideicomiso de Contragarantia para el Financiamiento Empresarial | XXXXXXXXXXXXX | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| | 34247 | NFI3406305T0 | 273817 | 2012-02-01 14:10:36 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | NaN | NaN | ENTREGA DE INTERESER A TERCEROS / AUT SESION COMITE DEL 02-JUL-08 PAGO NAFIN POR SUBSIDIO DE TASA DEL PROGRAMA EMERGENTE TABASCO DE FET ABONO A CTA 2351-3 DE TERCERO NACIONAL FINANCIERA, S.N.C. - GARANTIAS | ENTREGA DE INTERESES A TERCEROS | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 5.769100e+02 | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | 3091 | 80139 | Fideicomiso de Contragarantia para el Financiamiento Empresarial | Fideicomiso de Contragarantia para el Financiamiento Empresarial | XXXXXXXXXXXXX | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| | 34241 | NFI3406305T0 | 273818 | 2012-02-01 14:12:56 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | NaN | NaN | ENTREGA DE INTERESER A TERCEROS / AUT SESION COMITE DEL 02-JUL-08 PAGO NAFIN POR SUBSIDIO DE TASA DEL PROGRAMA EMERGENTE DEAN CHETUMAL A NAFIN DE TERCERO NACIONAL FINANCIERA, S.N.C. - GARANTIAS | ENTREGA DE INTERESES A TERCEROS | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 5.623400e+02 | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | 3091 | 80139 | Fideicomiso de Contragarantia para el Financiamiento Empresarial | Fideicomiso de Contragarantia para el Financiamiento Empresarial | XXXXXXXXXXXXX | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| | 34161 | NFI3406305T0 | 273819 | 2012-02-01 14:14:27 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | NaN | NaN | PAGO DE GARANTIAS / AUT SES COM 020708 PAGO DE CONTRAGARANTIA AL FISO 11480 X GTIA PAG 1317-2-2-199 BAJIO FH 080212 CTO 1062006 DE BENEFICIARIO NINGUNO | PAGO DE GARANTIAS SIN COMISION E IVA | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 3.540253e+05 | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 3091 | 80139 | Fideicomiso de Contragarantia para el Financiamiento Empresarial | Fideicomiso de Contragarantia para el Financiamiento Empresarial | XXXXXXXXXXXXX | 1020|||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN |INSURGENTES SUR |# 1971 TORRE IV PISO12 PLAZA INN||||| | 34376 | NFI3406305T0 | 273820 | 2012-02-01 14:15:32 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | NaN | NaN | PAGO DE GARANTIAS / AUT SES COM 020708 PAGO DE CONTRAGARANTIA AL FISO 11480 X GTIA PAG 1317-2-2-199 BAJIO FH 080212 CTO 1064277 DE BENEFICIARIO NINGUNO | PAGO DE GARANTIAS SIN COMISION E IVA | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 4.432477e+06 | NaN | NaN | NaN | NaN | NaN | NaN |
| OID_CUSTOMERS | CUSTOMER_ID | LEGAL_NAME | DESCRIPTION | RFC | ADDRESS_DUMP | OID_ACCOUNTS | RFC2 | ID_TRANSACTION | FECHA_DE_ENTRADA | FECHA_DE_ACUERDO | FECHA_DE_LIQUIDACION | FECHA_DE_ACUERDO_SERIE_PRI | FECHA_DE_ACUERDO_SERIE_SEC | FECHA_DE_FIN_DE_TRANSACCION | TASA_DE_TRANSACCION | COMENTARIOS_TX | CONCEPTO_TX | OBJETIVO_DEL_FIDEICOMISO | SUBTIPO_TX | MONTO_DE_COMISIONES | INTERES_LIMPIO_FUTURO | EXCEDENTE_UTILIZADO | MONTO_EN_DOLARES | TASA_DE_CAMBIO_DOLARES | MONTO_SERIE_PRI | MONTO_BRUTO | MONTO_ORDENADO | ID_DISPERSION | MONTO_DISPERSION | NOMBRE_DE_BENEFICIARIO | RFC_BENEFICIARIO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3149395 | 4478 | 80615 | FIDEICOMISO DE COBRANZA | FIDEICOMISO DE COBRANZA | XXXXXXXXXXXXX | 11000| ||DISTRITO FEDERAL|MEXICO |LOMAS DE CHAPULTEPEC |AV. PASEO DE LAS PALMAS |# 405-404||| || | 74306 | PIR090827MJ7 | 4014152 | 2025-02-19 17:47:25 | 2025-02-20 00:00:00 | NaN | 2025-02-21 00:00:00 | 2025-02-21 00:00:00 | NaN | NaN | Pago a las facturas 386/44741 y 386/44935 a nombre de Regus Management de México, S.A. de C.V. con fecha 05/01/2025 y 06/02/2025 respectivamente, por concepto de Pago de renta de oficina virtual por los meses de febrero y marzo 2025 para Promotora de Infraestructura Registral II, S.A. de C.V., SOFOM., E.R., Cuenta destino a nombre de México Business Center 39, SA de CV, Filial de Regus Management de México, S.A. de C.V. | PAGO DE ACREEDORES DIVERSOS | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 306.24 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3149396 | 4423 | 80320 | FONDO DE PENSIONES DEL SISTEMA BANRURAL | FONDO DE PENSIONES DEL SISTEMA BANRURAL | XXXXXXXXXXXXX | 1020| ||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN|INSURGENTES SUR |# 1971 TORRE III PISO 6 ||| || | 38871 | NFF030630458 | 4014167 | 2025-02-19 17:58:16 | 2025-02-20 00:00:00 | NaN | 2025-02-21 00:00:00 | 2025-02-21 00:00:00 | NaN | NaN | Pago a TALLER MONTESSORI DE MERIDA AC por concepto de servicio de arrendamiento de inmuebles del Enlace Regional Mérida, correspondiente al mes de diciembre de 2024, según factura con folio fiscal 71c3671c-21d6-41dd-8397-110c486d0c6f, contrato UR-FPSB-012-2024-911. (Subp pptal 7430). Gasto que corresponde al ejercicio 2024 y se liquida en el año 2025. | ENTREGA PATRIMONIAL | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 20543.60 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3149397 | 4423 | 80320 | FONDO DE PENSIONES DEL SISTEMA BANRURAL | FONDO DE PENSIONES DEL SISTEMA BANRURAL | XXXXXXXXXXXXX | 1020| ||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN|INSURGENTES SUR |# 1971 TORRE III PISO 6 ||| || | 38871 | NFF030630458 | 4014169 | 2025-02-19 18:02:49 | 2025-02-20 00:00:00 | NaN | 2025-02-21 00:00:00 | 2025-02-21 00:00:00 | NaN | NaN | Pago a ANTONIO OCHOA PALMA por concepto de servicio de arrendamiento de inmuebles del Enlace Regional Mazatlán localidad LOS MOCHIS, correspondiente al mes de diciembre de 2024, según factura con folio fiscal C92919F2-0FC4-5636-8A65-AA251524B0F1, contrato UR-FPSB-004-2024-905. (Subp pptal 7430). Gasto que corresponde al ejercicio 2024 y se liquida en el año 2025. | ENTREGA PATRIMONIAL | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 9926.10 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3149398 | 4423 | 80320 | FONDO DE PENSIONES DEL SISTEMA BANRURAL | FONDO DE PENSIONES DEL SISTEMA BANRURAL | XXXXXXXXXXXXX | 1020| ||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN|INSURGENTES SUR |# 1971 TORRE III PISO 6 ||| || | 38871 | NFF030630458 | 4014170 | 2025-02-19 18:04:49 | 2025-02-20 00:00:00 | NaN | 2025-02-21 00:00:00 | 2025-02-21 00:00:00 | NaN | NaN | Pago a INMUEBLES DE OPORTUNIDAD, S.A. DE C.V. por concepto de servicio de arrendamiento de inmuebles del Enlace Regional Veracruz, correspondiente al mes de diciembre de 2024, según factura con folio fiscal 5E2E1337-BD4D-4624-8872-4E48CD08C757, contrato UR-FPSB-011-2024-910. (Subp pptal 7430). Gasto que corresponde al ejercicio 2024 y se liquida en el año 2025. | ENTREGA PATRIMONIAL | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 20000.00 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3149399 | 4423 | 80320 | FONDO DE PENSIONES DEL SISTEMA BANRURAL | FONDO DE PENSIONES DEL SISTEMA BANRURAL | XXXXXXXXXXXXX | 1020| ||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN|INSURGENTES SUR |# 1971 TORRE III PISO 6 ||| || | 38871 | NFF030630458 | 4014172 | 2025-02-19 18:07:25 | 2025-02-20 00:00:00 | NaN | 2025-02-21 00:00:00 | 2025-02-21 00:00:00 | NaN | NaN | Pago a FUNDOS URBANOS MEXICANOS, S.A. DE C.V. por concepto de servicio de arrendamiento de inmuebles del Enlace Regional Torreón, correspondiente al mes de diciembre de 2024, según factura con folio fiscal 708B4F2C-F8DE-4307-A871-64EE9DF73E51, contrato UR-FPSB-002-2024-903. (Subp pptal 7430). Gasto que corresponde al ejercicio 2024 y se liquida en el año 2025. | ENTREGA PATRIMONIAL | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 19920.10 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3149400 | 4423 | 80320 | FONDO DE PENSIONES DEL SISTEMA BANRURAL | FONDO DE PENSIONES DEL SISTEMA BANRURAL | XXXXXXXXXXXXX | 1020| ||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN|INSURGENTES SUR |# 1971 TORRE III PISO 6 ||| || | 38871 | NFF030630458 | 4014173 | 2025-02-19 18:09:28 | 2025-02-20 00:00:00 | NaN | 2025-02-21 00:00:00 | 2025-02-21 00:00:00 | NaN | NaN | Pago a TURRUBIATES ORTÍZ ESMERALDA MÓNICA por concepto de servicio de arrendamiento de inmuebles del Enlace Regional Cd. Victoria, correspondiente al mes de diciembre de 2024, según factura con folio fiscal 9d156924-5da5-4fc2-9a1f-82b3d1615df9,contrato UR-FPSB-003-2024-904. (Subp pptal 7430). Gasto que corresponde al ejercicio 2024 y se liquida en el año 2025. | ENTREGA PATRIMONIAL | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 8103.33 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3149401 | 4423 | 80320 | FONDO DE PENSIONES DEL SISTEMA BANRURAL | FONDO DE PENSIONES DEL SISTEMA BANRURAL | XXXXXXXXXXXXX | 1020| ||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN|INSURGENTES SUR |# 1971 TORRE III PISO 6 ||| || | 38871 | NFF030630458 | 4014174 | 2025-02-19 18:11:40 | 2025-02-20 00:00:00 | NaN | 2025-02-21 00:00:00 | 2025-02-21 00:00:00 | NaN | NaN | Pago a MACIAS MERCADO MA. MERCEDES por concepto de servicio de arrendamiento de inmuebles del Enlace Regional Guadalajara, correspondiente al mes de diciembre de 2024, según factura con folio fiscal 01895A1A-7CF1-4A7F-94DD-9109B4C0A363, contrato UR-FPSB-006-2024-906. (Subp pptal 7430). Gasto que corresponde al ejercicio 2024 y se liquida en el año 2025. | ENTREGA PATRIMONIAL | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 46837.48 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3149402 | 4423 | 80320 | FONDO DE PENSIONES DEL SISTEMA BANRURAL | FONDO DE PENSIONES DEL SISTEMA BANRURAL | XXXXXXXXXXXXX | 1020| ||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN|INSURGENTES SUR |# 1971 TORRE III PISO 6 ||| || | 38871 | NFF030630458 | 4014176 | 2025-02-19 18:15:55 | 2025-02-20 00:00:00 | NaN | 2025-02-21 00:00:00 | 2025-02-21 00:00:00 | NaN | NaN | Pago a ITURBE MANDUJANO MARIO por concepto de servicio de arrendamiento de inmuebles del Enlace Regional Tuxtla, correspondiente al mes de diciembre de 2024, según factura con folio fiscal 05A9D980-73B2-4049-B824-6145A9A25D91, contrato UR-FPSB-013-2024-912. (Subp pptal 7430). Gasto que corresponde al ejercicio 2024 y se liquida en el año 2025. | ENTREGA PATRIMONIAL | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 22022.00 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3149403 | 4478 | 80615 | FIDEICOMISO DE COBRANZA | FIDEICOMISO DE COBRANZA | XXXXXXXXXXXXX | 11000| ||DISTRITO FEDERAL|MEXICO |LOMAS DE CHAPULTEPEC |AV. PASEO DE LAS PALMAS |# 405-404||| || | 74306 | PIR090827MJ7 | 4014136 | 2025-02-19 17:29:55 | 2025-02-20 00:00:00 | NaN | 2025-02-21 00:00:00 | 2025-02-21 00:00:00 | NaN | NaN | Pago a las facturas 386/44741 y 386/44935 a Regus Management de México, S.A. de C.V. con fecha 05/01/2025 y 06/02/2025 respectivamente, por Pago de renta de oficina virtual por los meses de febrero y marzo 2025 para Promotora de Infraestructura Registral II, S.A. de C.V., SOFOM., E.R., cuenta destino a nombre de México Business Center 39, SA de CV, empresa Filial que opera en gestión de cobranza como agente por y en nombre de Regus Management de México, S.A. de C.V. | PAGO DE ACREEDORES DIVERSOS | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 306.24 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3149404 | 4423 | 80320 | FONDO DE PENSIONES DEL SISTEMA BANRURAL | FONDO DE PENSIONES DEL SISTEMA BANRURAL | XXXXXXXXXXXXX | 1020| ||DISTRITO FEDERAL|ALVARO OBREGON |GUADALUPE INN|INSURGENTES SUR |# 1971 TORRE III PISO 6 ||| || | 38871 | NFF030630458 | 4014165 | 2025-02-19 17:55:44 | 2025-02-20 00:00:00 | NaN | 2025-02-21 00:00:00 | 2025-02-21 00:00:00 | NaN | NaN | Pago a MAYA TALAVERA MARÍA TERESA por concepto de servicio de arrendamiento de inmuebles del Enlace Regional Zamora localidad Morelia, correspondiente al mes de diciembre de 2024, según factura con folio fiscal 350A166D-6600-474D-81E2-6A3CF16F6DBE, contrato UR-FPSB-008-2024-908. (Subp pptal 7430). Gasto que corresponde al ejercicio 2024 y se liquida en el año 2025. | ENTREGA PATRIMONIAL | NaN | CORTO PLAZO | 0.0 | NaN | NaN | NaN | NaN | 10010.00 | NaN | NaN | NaN | NaN | NaN | NaN |